Table of Contents

	Click an underlined title to display the topic you want to read. About FileMaker Pro Web Companion About Table View About Form View Searching for Records Sorting Records Adding Records Editing Records Deleting Records © 1999 FileMaker, Inc. All Rights Reserved. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. Java, 100% Pure Java, and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. All other trademarks are the property of their respective owners.

About FileMaker Pro Web Companion

	Welcome to FileMaker Pro Web Companion help. The FileMaker Pro Web Companion instantly publishes FileMaker Pro databases on the World Wide Web. On the FileMaker Pro Web Companion home page, click the name of the database that contains information you want to view, find, sort, or update. Some databases require passwords. If the Password dialog box displays after you click a database name, type your password. (You can leave the user name blank.) Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action (like creating records) or item on the page (like the New Record button). If a page doesn't display correctly, be sure JavaScriptTM is enabled in your Web browser. (See your browser documentation for more information.) [ Table of Contents ]

About Table View

	Click Table View to view multiple records at one time. For the best performance, display a small range of records. On some Table View pages, you see information about the records you are browsing, such as the total number of records in the database, the number of records that have met your search criteria, and the sort status. Click To Form View View details about the first record displayed in the table. You can also click the number on the left side of a record to view the details. Search Look for a particular record or group of records New Record Add a record to the database Show All View all records after searching, or after creating a record Sort Rearrange the records Previous View the previous range of records Next View the next range of records Home Choose another database On some Table View pages, you can specify the range of records you want to view. Type the range in the Record Range box (for example, 1-5), then press . Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. [ Table of Contents ]

About Form View

	Click Form View to view one record at a time. In Table View, you can also click the number on the left side of a record to switch to Form View. On some Form View pages, you see information about the records you are browsing, such as the total number of records in the database, the number of records that have met your search criteria, and the sort status. Click To Table View View multiple records at one time Search Look for a particular record or group of records New Record Add a record to the database Edit Record Modify the current record Delete Record Permanently delete the current record from the database Show All View all records after searching, or after creating a record Sort Rearrange the records Previous View the previous record Next View the next record Home Choose another database On some Form View pages, you can specify the record you want to view. Type the record number in the Record box (for example, 2), then press . Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. [ Table of Contents ]

Searching for Records

	You can search for a particular record or a group of records. To find records, you specify search criteria (the values you want to find) in the Search page. A search examines all the records in the database and returns the search results, the set of records that matches the search criteria. The search results are displayed in Table View. To display all the records in the database, click Show All in Table View or Form View. To find a record or group of records: Click Search. On the Search page, choose Match all words on page (AND) to find values that match all the search criteria in the same field or across fields. Choose Match any word on page (OR) to find values that match one or more search criteria in the same field or across fields. See Search tips for more information. Choose the type of search next to the field you want to search on. For the field you want to search on, enter the search criteria. To refine your search, you can type additional operators for the field you want to search. For example, to find all the records that are between five and ten, type 5...10 directly into the Criteria field. See the table of operators for more information. Note There are some types of fields that can't be searched. (For example, you can't search a field that contains a picture). These fields may appear on the Search page, but you can't enter search criteria for them. Repeat steps 3 and 4 for as many fields as you want to search (for example, a specific last name and first name). Click Start Search to search the database. The record or records are displayed in Table View. Click To Table View Return to Table View without searching the database Form View Return to Form View without searching the database Clear Form Reset the search criteria Back Return to Table View or Form View without searching the database Home Choose another database Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. Search Tips The Match all words on page (AND) and Match any word on page (OR) options search both inside and across fields. To search for Select And type All records in the city of San Francisco (but not other cities whose names contain either "San" or "Francisco") Match all words on page (AND) San Francisco in the City field All records in the cities of San Francisco or Paris (as well as all cities whose names contain either "San", "Francisco", or "Paris") Match any word on page (OR) San Francisco Paris in the City field All records in the city of Paris and the country of France Match all words on page (AND) Paris in the City field and France in the Country field All records in any city named Paris, as well as all cities in the country of France Match any word on page (OR) Paris in the City field and France in the Country field Note You cannot combine AND/OR searches on a page. You can refine your search by using the following operators inside the field. For example: To find values that are Use this operator Example Less than what you type next < <40 finds all the records less than 40 Less than or equal to what you type next <= <=05:00:00 finds all the records less than or equal to five o'clock Greater than what you type next > >05:00:00 finds all the records after 5:00 Greater than or equal to what you type next >= >=Smith finds all the records whose name is "Smith" and all records alphabetically after "Smith" An exact match, although the field may contain other values = (before criteria) =Smith finds all the records where the name is "Smith," including "John Smith," but not Smithson An exact match, in the order you specify, and the field contains no other values == (before criteria) ==Smith finds all the records where the name is "Smith," but not "John Smith" or "Smithson" Within the range you specify ... (3 periods) 12:30...17:30 finds all the records between 12:30 and 17:30 Duplicate values ! ! finds all the records that have duplicate values in a field Today's date // // finds all the records that have today's date Invalid dates or times ? ? finds all the records that have invalid dates or times One unknown or variable text character @ @on finds all the records that have 3 characters and end in "on," like "Don" Zero or more unknown or variable text characters * *smith* finds all the records that have "smith" in the name, like "Smithson," "Blacksmith" Literal text in a field (to find characters that aren't automatically searched, such as ",") " " ", Ltd." finds all the records that have ", Ltd." Empty fields (for example, records of unfilled orders) = = finds all the records that have no values [ Table of Contents ]

Sorting Records

	You can rearrange the order of the records in a database. Records can be sorted in ascending order, descending order, or a custom order based on a list of predefined values. To sort records: In Table View or Form View, click Sort. On the Sort page, choose the first field (for example, Last Name) and the sort order. To sort on additional fields (for example, Last Name and then First Name), choose the fields and sort order. You can sort on up to four fields. Click Start Sort. Click To Clear Form Reset the sort order or choose different fields to sort by Back Return to Table View or Form View without sorting records Home Choose another database Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. [ Table of Contents ]

Adding Records

	Use the New Record page to add information to a database. To add a record: In Table View or Form View, click New Record. On the New Record page, click in a field to enter the new information. Press Tab to move between fields. When you finish entering the information into the fields, click Submit to add the record to the database. Click To Clear Form Clear the information you've entered Back Return to Table View or Form View without adding a record Home Choose another database Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. [ Table of Contents ]

Editing Records

	Use the Edit Record page to permanently modify a record in the database. To edit a record: In Form View, click Edit Record. In Table View, select the record you want to edit by clicking the number on the left side of the record. Then click Edit Record in Form View. On the Edit Record page, click in a field to make changes. When you finish changing the information in the fields, click Submit. Click To Clear Form Undo changes and return to the original field values. You cannot revert to the original values after you click Submit. Back Return to Form View without saving your changes Home Choose another database Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. [ Table of Contents ]

Deleting Records

	In Form View, you can delete a record from the database. When you delete a record, you permanently discard the data that is entered in all the fields in that record. To delete a record: In Form View, click Delete Record. In Table View, select the record you want to delete by clicking the number on the left side of the record. Then click Delete Record in Form View. You see a message confirming your request to delete the current record. Click Delete to delete the record. Or, click Back to return to Form View without deleting the record. Note The person who designs the database sets options for the pages and data that you see. You might not have access to every database action or item on the page. [ Table of Contents ]